Code Context
$column_sidebar_html = trim(file_get_contents($column_url));
echo substr($column_sidebar_html, 45);
$viewFile = '/var/www/htdocs/moteo/portal/src/Template/Element/Front/aside.ctp'
$dataForView = [
'keyword_for_layout' => '',
'title_for_layout' => '水戸皮膚科クリニック|MOTEO(モテオ)',
'h1_for_layout' => '',
'description_for_layout' => '',
'structureds' => [
(int) 0 => '{
"@context": "http://schema.org",
"@type": "Review",
"itemReviewed": {
"@type": "MedicalClinic",
"name": "水戸皮膚科クリニック",
"image": "",
"@id": "https://moteo.best/aga/shop/3612/",
"url": "https://moteo.best/aga/shop/3612/",
"telephone": "029-226-8381",
"address": {
"@type": "PostalAddress",
"addressLocality": "水戸市",
"addressRegion": "茨城県",
"streetAddress": "松が丘1-4-30"
}
},
"aggregateRating": {
"@type": "AggregateRating",
"bestRating": 0,
"worstRating": 0,
"ratingValue": "",
"reviewCount": 0
},
"openingHoursSpecification": {
"@type": "openingHoursSpecification",
"dayOfWeek": "木曜、日、祝"
},
"geo": {
"@type": "GeoCoordinates",
"latitude": "36.3866853",
"longitude": "140.4366301"
}
}',
(int) 1 => '[]'
],
'shop' => [
'shop_id' => (int) 3612,
'area_id' => (int) 128,
'pref' => '茨城県',
'address' => '松が丘1-4-30',
'name' => '水戸皮膚科クリニック',
'description_subject' => '腕が良いと評判の先生がいるクリニック',
'description_content' => '水戸市でAGA治療を行っている病院をお探しなら水戸皮膚科クリニックがおすすめ!',
'access' => '',
'business_hours' => '午前:9:30~12:30午後:14:30~18:30',
'holiday' => '木曜、日、祝',
'doctor' => null,
'credit_card' => '',
'facility' => '',
'staff' => '',
'parking' => '',
'conditions' => '',
'memo' => '',
'station' => 'JR常磐線 赤塚駅から徒歩25分',
'brand_id' => null,
'price_plan_html' => '',
'shop_image_path' => null,
'word' => '',
'interview_title' => null,
'interview_content' => null,
'interview_image_path' => null,
'interview_eyecatch_image_path' => null,
'interview_video_url' => null,
'affiliate_page_url' => '',
'affiliate_banner_url' => '',
'scraping_url' => '',
'shop_type' => null,
'show_flg' => (int) 1,
'created' => object(Cake\I18n\FrozenTime) {},
'create_user' => (int) 37,
'modified' => object(Cake\I18n\FrozenTime) {},
'modify_user' => (int) 37,
'del_flg' => (int) 1,
'free_counseling' => (int) 1,
'campaign_html' => '',
'hook_details' => '',
'moteo_cash_back' => '',
'tel' => '029-226-8381',
'latitude' => '36.3866853',
'longitude' => '140.4366301',
'show_form_flg' => (int) 2,
'quote_image_url' => 'https://static.byoinnavi.jp/images/corp/480/326/66326.153369ca.jpg',
'star' => null,
'review_cnt' => '0',
'blogs' => [],
'infos' => [],
'interviews' => [],
'staffs' => [],
'reviews' => [],
'shop_access_images' => [],
'shop_images' => [],
'prices' => [],
'other_conditions' => [
(int) 0 => [
[maximum depth reached]
],
(int) 1 => [
[maximum depth reached]
]
],
'discounts' => [],
'payments' => [
(int) 0 => [
[maximum depth reached]
]
],
'medication_types' => [],
'therapies' => [],
'target_ages' => [
(int) 0 => [
[maximum depth reached]
],
(int) 1 => [
[maximum depth reached]
],
(int) 2 => [
[maximum depth reached]
],
(int) 3 => [
[maximum depth reached]
],
(int) 4 => [
[maximum depth reached]
]
],
'bald_sites' => [
(int) 0 => [
[maximum depth reached]
]
],
'Brand' => [
'name' => null,
'brand_id' => null
],
'PrefData' => [
'url_text' => 'ibaragi'
],
'Area' => [
'area_id' => '128',
'name' => '水戸市'
],
'Station' => [
(int) 0 => [
[maximum depth reached]
]
],
'StationG' => [
(int) 0 => [
[maximum depth reached]
]
]
],
'othreShops' => [
'station_data' => object(Cake\ORM\Query) {},
'area_data' => object(Cake\ORM\Query) {},
'shop_data' => object(Cake\ORM\Query) {}
],
'brandUrls' => object(Cake\ORM\ResultSet) {
'items' => [[maximum depth reached]]
},
'refere' => '/'
]
$keyword_for_layout = ''
$title_for_layout = '水戸皮膚科クリニック|MOTEO(モテオ)'
$h1_for_layout = ''
$description_for_layout = ''
$structureds = [
(int) 0 => '{
"@context": "http://schema.org",
"@type": "Review",
"itemReviewed": {
"@type": "MedicalClinic",
"name": "水戸皮膚科クリニック",
"image": "",
"@id": "https://moteo.best/aga/shop/3612/",
"url": "https://moteo.best/aga/shop/3612/",
"telephone": "029-226-8381",
"address": {
"@type": "PostalAddress",
"addressLocality": "水戸市",
"addressRegion": "茨城県",
"streetAddress": "松が丘1-4-30"
}
},
"aggregateRating": {
"@type": "AggregateRating",
"bestRating": 0,
"worstRating": 0,
"ratingValue": "",
"reviewCount": 0
},
"openingHoursSpecification": {
"@type": "openingHoursSpecification",
"dayOfWeek": "木曜、日、祝"
},
"geo": {
"@type": "GeoCoordinates",
"latitude": "36.3866853",
"longitude": "140.4366301"
}
}',
(int) 1 => '[]'
]
$shop = [
'shop_id' => (int) 3612,
'area_id' => (int) 128,
'pref' => '茨城県',
'address' => '松が丘1-4-30',
'name' => '水戸皮膚科クリニック',
'description_subject' => '腕が良いと評判の先生がいるクリニック',
'description_content' => '水戸市でAGA治療を行っている病院をお探しなら水戸皮膚科クリニックがおすすめ!',
'access' => '',
'business_hours' => '午前:9:30~12:30午後:14:30~18:30',
'holiday' => '木曜、日、祝',
'doctor' => null,
'credit_card' => '',
'facility' => '',
'staff' => '',
'parking' => '',
'conditions' => '',
'memo' => '',
'station' => 'JR常磐線 赤塚駅から徒歩25分',
'brand_id' => null,
'price_plan_html' => '',
'shop_image_path' => null,
'word' => '',
'interview_title' => null,
'interview_content' => null,
'interview_image_path' => null,
'interview_eyecatch_image_path' => null,
'interview_video_url' => null,
'affiliate_page_url' => '',
'affiliate_banner_url' => '',
'scraping_url' => '',
'shop_type' => null,
'show_flg' => (int) 1,
'created' => object(Cake\I18n\FrozenTime) {
'time' => '2019-09-29T17:30:17+09:00',
'timezone' => 'Asia/Tokyo',
'fixedNowTime' => false
},
'create_user' => (int) 37,
'modified' => object(Cake\I18n\FrozenTime) {
'time' => '2023-06-11T20:04:18+09:00',
'timezone' => 'Asia/Tokyo',
'fixedNowTime' => false
},
'modify_user' => (int) 37,
'del_flg' => (int) 1,
'free_counseling' => (int) 1,
'campaign_html' => '',
'hook_details' => '',
'moteo_cash_back' => '',
'tel' => '029-226-8381',
'latitude' => '36.3866853',
'longitude' => '140.4366301',
'show_form_flg' => (int) 2,
'quote_image_url' => 'https://static.byoinnavi.jp/images/corp/480/326/66326.153369ca.jpg',
'star' => null,
'review_cnt' => '0',
'blogs' => [],
'infos' => [],
'interviews' => [],
'staffs' => [],
'reviews' => [],
'shop_access_images' => [],
'shop_images' => [],
'prices' => [],
'other_conditions' => [
(int) 0 => [
'other_condition_id' => (int) 1,
'name' => '皮膚科',
'search_text' => '皮膚科',
'url_text' => 'dermatology',
'description' => '',
'html' => null,
'type' => (int) 2,
'created' => object(Cake\I18n\FrozenTime) {},
'create_user' => (int) 0,
'modified' => object(Cake\I18n\FrozenTime) {},
'modify_user' => (int) 1,
'del_flg' => (int) 1,
'_joinData' => [
[maximum depth reached]
]
],
(int) 1 => [
'other_condition_id' => (int) 17,
'name' => '駐車場あり',
'search_text' => '駐車場あり',
'url_text' => 'parking',
'description' => '',
'html' => null,
'type' => (int) 5,
'created' => object(Cake\I18n\FrozenTime) {},
'create_user' => (int) 0,
'modified' => object(Cake\I18n\FrozenTime) {},
'modify_user' => (int) 1,
'del_flg' => (int) 1,
'_joinData' => [
[maximum depth reached]
]
]
],
'discounts' => [],
'payments' => [
(int) 0 => [
'payment_id' => (int) 1,
'name' => '現金可',
'search_text' => '現金可',
'url_text' => 'cash',
'description' => '',
'html' => null,
'created' => object(Cake\I18n\FrozenTime) {},
'create_user' => (int) 0,
'modified' => object(Cake\I18n\FrozenTime) {},
'modify_user' => (int) 1,
'del_flg' => (int) 1,
'_joinData' => [
[maximum depth reached]
]
]
],
'medication_types' => [],
'therapies' => [],
'target_ages' => [
(int) 0 => [
'target_age_id' => (int) 2,
'name' => '20代',
'search_text' => '20代',
'url_text' => '20-age',
'description' => '',
'html' => null,
'created' => object(Cake\I18n\FrozenTime) {},
'create_user' => (int) 0,
'modified' => object(Cake\I18n\FrozenTime) {},
'modify_user' => (int) 1,
'del_flg' => (int) 1,
'_joinData' => [
[maximum depth reached]
]
],
(int) 1 => [
'target_age_id' => (int) 3,
'name' => '30代',
'search_text' => '30代',
'url_text' => '30-age',
'description' => '',
'html' => null,
'created' => object(Cake\I18n\FrozenTime) {},
'create_user' => (int) 0,
'modified' => object(Cake\I18n\FrozenTime) {},
'modify_user' => (int) 1,
'del_flg' => (int) 1,
'_joinData' => [
[maximum depth reached]
]
],
(int) 2 => [
'target_age_id' => (int) 4,
'name' => '40代',
'search_text' => '40代',
'url_text' => '40-age',
'description' => '',
'html' => null,
'created' => object(Cake\I18n\FrozenTime) {},
'create_user' => (int) 0,
'modified' => object(Cake\I18n\FrozenTime) {},
'modify_user' => (int) 1,
'del_flg' => (int) 1,
'_joinData' => [
[maximum depth reached]
]
],
(int) 3 => [
'target_age_id' => (int) 5,
'name' => '50代',
'search_text' => '50代',
'url_text' => '50-age',
'description' => '',
'html' => null,
'created' => object(Cake\I18n\FrozenTime) {},
'create_user' => (int) 0,
'modified' => object(Cake\I18n\FrozenTime) {},
'modify_user' => (int) 1,
'del_flg' => (int) 1,
'_joinData' => [
[maximum depth reached]
]
],
(int) 4 => [
'target_age_id' => (int) 6,
'name' => '60代〜',
'search_text' => '60代〜',
'url_text' => '60-age',
'description' => '',
'html' => null,
'created' => object(Cake\I18n\FrozenTime) {},
'create_user' => (int) 0,
'modified' => object(Cake\I18n\FrozenTime) {},
'modify_user' => (int) 1,
'del_flg' => (int) 1,
'_joinData' => [
[maximum depth reached]
]
]
],
'bald_sites' => [
(int) 0 => [
'bald_site_id' => (int) 3,
'name' => 'M・O型',
'search_text' => 'M・O型',
'url_text' => 'mo-type',
'description' => '',
'html' => null,
'created' => object(Cake\I18n\FrozenTime) {},
'create_user' => (int) 0,
'modified' => object(Cake\I18n\FrozenTime) {},
'modify_user' => (int) 1,
'del_flg' => (int) 1,
'_joinData' => [
[maximum depth reached]
]
]
],
'Brand' => [
'name' => null,
'brand_id' => null
],
'PrefData' => [
'url_text' => 'ibaragi'
],
'Area' => [
'area_id' => '128',
'name' => '水戸市'
],
'Station' => [
(int) 0 => [
'station_cd' => '1122915',
'name' => 'JR常磐線(取手~いわき)/赤塚駅',
'area_id' => '128'
]
],
'StationG' => [
(int) 0 => [
'station_g_cd' => '1122915',
'name' => '赤塚駅',
'area_id' => '128'
]
]
]
$othreShops = [
'station_data' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Shops.shop_id AS `Shops__shop_id`, Shops.name AS `Shops__name`, Shops.pref AS `Shops__pref`, Shops.area_id AS `Shops__area_id`, Shops.address AS `Shops__address`, Shops.shop_type AS `Shops__shop_type`, Shops.show_flg AS `Shops__show_flg`, Shops.business_hours AS `Shops__business_hours`, Shops.holiday AS `Shops__holiday`, Shops.doctor AS `Shops__doctor`, Shops.station AS `Shops__station`, Shops.description_subject AS `Shops__description_subject`, Shops.description_content AS `Shops__description_content`, Shops.affiliate_page_url AS `Shops__affiliate_page_url`, Shops.affiliate_banner_url AS `Shops__affiliate_banner_url`, Shops.free_counseling AS `Shops__free_counseling`, Shops.campaign_html AS `Shops__campaign_html`, Shops.hook_details AS `Shops__hook_details`, Shops.moteo_cash_back AS `Shops__moteo_cash_back`, Shops.tel AS `Shops__tel`, Shops.latitude AS `Shops__latitude`, Shops.longitude AS `Shops__longitude`, Shops.quote_image_url AS `Shops__quote_image_url`, Shops.show_form_flg AS `Shops__show_form_flg`, Shops.modified AS `Shops__modified`, Area.name AS `Area__name`, Area.area_id AS `Area__area_id`, PrefData.search_text AS `PrefData__search_text`, PrefData.pref AS `PrefData__pref`, PrefData.url_text AS `PrefData__url_text`, (SELECT COUNT(review_id) AS `review_cnt` FROM aga_reviews Reviews WHERE (shop_id = Shops.shop_id AND show_flg = :c0 AND del_flg = 1)) AS `review_cnt`, (SELECT AVG(evaluation) AS `review_cnt` FROM aga_reviews Reviews WHERE (shop_id = Shops.shop_id AND show_flg = :c0 AND del_flg = 1)) AS `star` FROM aga_shops Shops LEFT JOIN aga_areas Area ON (Area.area_id = Shops.area_id AND Area.del_flg = :c0) LEFT JOIN aga_pref_datas PrefData ON (PrefData.pref = Shops.pref AND PrefData.del_flg = :c1) INNER JOIN aga_shop_stations ShopStation ON (ShopStation.shop_id = Shops.shop_id AND ShopStation.del_flg = :c2) INNER JOIN aga_stations Station ON Station.station_cd = ShopStation.station_cd WHERE (Shops.show_flg = :c3 AND Shops.del_flg = :c4 AND ShopStation.station_cd in (:c5) AND ShopStation.station_cd in (:c6) AND NOT (Shops.shop_id in (:c7))) GROUP BY Shops.shop_id ORDER BY Shops.affiliate_page_url desc, rand() LIMIT 3',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
[maximum depth reached]
],
'matching' => [[maximum depth reached]],
'extraOptions' => [
[maximum depth reached]
],
'repository' => object(App\Model\Table\ShopsTable) {}
},
'area_data' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Shops.shop_id AS `Shops__shop_id`, Shops.name AS `Shops__name`, Shops.pref AS `Shops__pref`, Shops.area_id AS `Shops__area_id`, Shops.address AS `Shops__address`, Shops.shop_type AS `Shops__shop_type`, Shops.show_flg AS `Shops__show_flg`, Shops.business_hours AS `Shops__business_hours`, Shops.holiday AS `Shops__holiday`, Shops.doctor AS `Shops__doctor`, Shops.station AS `Shops__station`, Shops.description_subject AS `Shops__description_subject`, Shops.description_content AS `Shops__description_content`, Shops.affiliate_page_url AS `Shops__affiliate_page_url`, Shops.affiliate_banner_url AS `Shops__affiliate_banner_url`, Shops.free_counseling AS `Shops__free_counseling`, Shops.campaign_html AS `Shops__campaign_html`, Shops.hook_details AS `Shops__hook_details`, Shops.moteo_cash_back AS `Shops__moteo_cash_back`, Shops.tel AS `Shops__tel`, Shops.latitude AS `Shops__latitude`, Shops.longitude AS `Shops__longitude`, Shops.quote_image_url AS `Shops__quote_image_url`, Shops.show_form_flg AS `Shops__show_form_flg`, Shops.modified AS `Shops__modified`, Area.name AS `Area__name`, Area.area_id AS `Area__area_id`, PrefData.search_text AS `PrefData__search_text`, PrefData.pref AS `PrefData__pref`, PrefData.url_text AS `PrefData__url_text`, (SELECT COUNT(review_id) AS `review_cnt` FROM aga_reviews Reviews WHERE (shop_id = Shops.shop_id AND show_flg = :c0 AND del_flg = 1)) AS `review_cnt`, (SELECT AVG(evaluation) AS `review_cnt` FROM aga_reviews Reviews WHERE (shop_id = Shops.shop_id AND show_flg = :c0 AND del_flg = 1)) AS `star` FROM aga_shops Shops LEFT JOIN aga_areas Area ON (Area.area_id = Shops.area_id AND Area.del_flg = :c0) LEFT JOIN aga_pref_datas PrefData ON (PrefData.pref = Shops.pref AND PrefData.del_flg = :c1) WHERE (Shops.show_flg = :c2 AND Shops.del_flg = :c3 AND Shops.area_id = :c4 AND NOT (Shops.shop_id in (:c5))) GROUP BY Shops.shop_id ORDER BY Shops.affiliate_page_url desc, rand() LIMIT 3',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
[maximum depth reached]
],
'matching' => [[maximum depth reached]],
'extraOptions' => [
[maximum depth reached]
],
'repository' => object(App\Model\Table\ShopsTable) {}
},
'shop_data' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Shops.shop_id AS `Shops__shop_id`, Shops.name AS `Shops__name`, Shops.pref AS `Shops__pref`, Shops.area_id AS `Shops__area_id`, Shops.address AS `Shops__address`, Shops.shop_type AS `Shops__shop_type`, Shops.show_flg AS `Shops__show_flg`, Shops.business_hours AS `Shops__business_hours`, Shops.holiday AS `Shops__holiday`, Shops.doctor AS `Shops__doctor`, Shops.station AS `Shops__station`, Shops.description_subject AS `Shops__description_subject`, Shops.description_content AS `Shops__description_content`, Shops.affiliate_page_url AS `Shops__affiliate_page_url`, Shops.affiliate_banner_url AS `Shops__affiliate_banner_url`, Shops.free_counseling AS `Shops__free_counseling`, Shops.campaign_html AS `Shops__campaign_html`, Shops.hook_details AS `Shops__hook_details`, Shops.moteo_cash_back AS `Shops__moteo_cash_back`, Shops.tel AS `Shops__tel`, Shops.latitude AS `Shops__latitude`, Shops.longitude AS `Shops__longitude`, Shops.quote_image_url AS `Shops__quote_image_url`, Shops.show_form_flg AS `Shops__show_form_flg`, Shops.modified AS `Shops__modified`, Area.name AS `Area__name`, Area.area_id AS `Area__area_id`, PrefData.search_text AS `PrefData__search_text`, PrefData.pref AS `PrefData__pref`, PrefData.url_text AS `PrefData__url_text`, (SELECT COUNT(review_id) AS `review_cnt` FROM aga_reviews Reviews WHERE (shop_id = Shops.shop_id AND show_flg = :c0 AND del_flg = 1)) AS `review_cnt`, (SELECT AVG(evaluation) AS `review_cnt` FROM aga_reviews Reviews WHERE (shop_id = Shops.shop_id AND show_flg = :c0 AND del_flg = 1)) AS `star` FROM aga_shops Shops LEFT JOIN aga_areas Area ON (Area.area_id = Shops.area_id AND Area.del_flg = :c0) LEFT JOIN aga_pref_datas PrefData ON (PrefData.pref = Shops.pref AND PrefData.del_flg = :c1) WHERE (Shops.show_flg = :c2 AND Shops.del_flg = :c3 AND Shops.pref = :c4 AND NOT (Shops.shop_id in (:c5))) GROUP BY Shops.shop_id ORDER BY Shops.affiliate_page_url desc, rand() LIMIT 3',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [
[maximum depth reached]
],
'matching' => [[maximum depth reached]],
'extraOptions' => [
[maximum depth reached]
],
'repository' => object(App\Model\Table\ShopsTable) {}
}
]
$brandUrls = object(Cake\ORM\ResultSet) {
'items' => []
}
$refere = '/'
$column_url = 'https://moteo.best/column/sidebar/aga/'
$ranking_option = ''
$pickup_option = ''
$current_url = '/aga/shop/3612/'
$genre = 'aga'
$http_response_header = [
(int) 0 => 'HTTP/1.1 403 Forbidden',
(int) 1 => 'Server: awselb/2.0',
(int) 2 => 'Date: Fri, 01 Nov 2024 03:48:51 GMT',
(int) 3 => 'Content-Type: text/html',
(int) 4 => 'Content-Length: 118',
(int) 5 => 'Connection: close'
]
file_get_contents - [internal], line ??
include - APP/Template/Element/Front/aside.ctp, line 27
Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1240
Cake\View\View::_render() - CORE/src/View/View.php, line 1201
Cake\View\View::_renderElement() - CORE/src/View/View.php, line 1598
Cake\View\View::element() - CORE/src/View/View.php, line 706
include - APP/Template/Front/Aga/Shops/detail.ctp, line 1309
Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1240
Cake\View\View::_render() - CORE/src/View/View.php, line 1201
Cake\View\View::render() - CORE/src/View/View.php, line 803
Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 790
App\Controller\Front\FrontAppController::move() - APP/Controller/Front/FrontAppController.php, line 101
App\Controller\Front\Aga\ShopsController::detail() - APP/Controller/Front/Aga/ShopsController.php, line 224
Cake\Controller\Controller::invokeAction() - CORE/src/Controller/Controller.php, line 609
Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 120
Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 94
Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 235